﻿CREATE TABLE "INTEX"."ICC_ABAUFM" 
   (	"ABAID" NUMBER, 
	"ABAMANDANT" CHAR(2), 
	"ABAAUFTYP" CHAR(1), 
	"ABAAUFKRS" CHAR(2), 
	"ABAAUFLFD" CHAR(6), 
	"ABAAUFPOS" CHAR(3), 
	"ABAAPOS" CHAR(4), 
	"ABAART" CHAR(20), 
	"ABAVAR" CHAR(3), 
	"ABAFARBE" CHAR(10), 
	"ABAGROE" CHAR(7), 
	"ABACOLORREF" CHAR(100), 
	"ABAERLKZ" CHAR(1), 
	"ABARESMG" NUMBER(22,5), 
	"ABAQTYRESERVE" NUMBER(22,5), 
	"ABAQTYALLOCATE" NUMBER(22,5), 
	"ABAQTYRECEIVED" NUMBER(22,5), 
	"ABAVKAUFTYP" CHAR(1), 
	"ABAVKAUFKRS" CHAR(2), 
	"ABAVKAUFLFD" CHAR(6), 
	"ABAVKAUFPOS" CHAR(3), 
	"ABAVKUPOS" CHAR(2), 
	"WAFGRLFD" NUMBER(9,0), 
	"WAUEBM" CHAR(3), 
	FSARTPRGR CHAR(3), 	
	"ABPART" CHAR(20), 
	"ABPVAR" CHAR(3), 
	"ABPFARBE" CHAR(10), 
	"ABPGROE" CHAR(7), 
	"FSABEZ" CHAR(40), 
	"FSFFBEZ" CHAR(20), 
	"LSLIEFNR" CHAR(8), 
	"LSLIEFNA" CHAR(10), 
	"ABANEUDAT" NUMBER(9,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 10485760 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA" ;
  DROP TABLE ICC_SECTION
GO
CREATE TABLE ICC_SECTION AS
select SDSA,SUBSTR(SDKEY,3,10)AS SDKEY,SUBSTR(SDDATEN,2,10) AS SDDATEN  from sddat where sdsa='0247'
AND SDKEY LIKE '%V'
GO